﻿CREATE TABLE [CoffeeShop].[PurchaseOrder] (
    [PurchaseOrderId]     INT           IDENTITY (1, 1) NOT NULL,
    [UserId]              INT           NULL,
    [UserName]            NVARCHAR (50) NULL,
    [TotalCost]           FLOAT         NOT NULL,
    [PurchaseOrderStatus] NCHAR (10)    NOT NULL
);

